package com.company.service.impl;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.base.common.persistence.utils.SqlMapper;
import com.base.common.service.CrudService;
import com.base.common.utils.SQLUtil;
import com.company.model.CompanyDevice;
import com.company.model.CompanyProject;
import com.company.service.CompanyJobService;

@Service
public class CompanyJobServiceImpl implements CompanyJobService {

	@Autowired
	SqlMapper sqlMapper;

	public List<Map<String, Object>> findJobByUserIdAndStatus(String userId,
			String status) throws Exception {
		Map<String, String> params = new HashMap<String, String>();
		params.put("userId", userId);
		params.put("status", status);
		String sql = "SELECT * from expense_assign t where t.user_id = #{userId} and t.status = #{status}";
		List<Map<String, Object>> list = sqlMapper.selectList(sql, params);

		return list;
	}
}
